{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Data Entry","Base costs","AMPE calc","MCVE calc"],"not_rendered":{"charts":0,"images":9,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Entry","index":0,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
["AMPE & MCVE tool"]
["Source: AHDB"]
[]
[null,"YOUR DATA",{"$nulls":5},"BASE DATA",{"$nulls":5},"DATA USED IN CALCULATION"]
[null,"leave blank if not available",{"$nulls":5},"These figures will be used by the calculator",{"$nulls":5},"This is what's going into the tool - a mix of your"]
[{"$nulls":7},"wherever your data is not provided",{"$nulls":5},"data and base data to fill gaps"]
[null,"Milk composition:","AMPE","MCVE","Notes",null,null,"Milk composition:","Combined",{"$nulls":4},"Milk composition:","AMPE","MCVE","Input"]
[null,"Fat",{"$nulls":5},"Fat",4.1000000000000002E-2,{"$nulls":4},"Fat",{"$f":"IF(ISBLANK(C9)=TRUE,I9,C9)","v":4.1000000000000002E-2},{"$f":"IF(ISBLANK(D9)=TRUE,I9,D9)","v":4.1000000000000002E-2},{"$f":"CONCATENATE(IF(ISBLANK(C9)=TRUE,\"Base data\",\"Your data\"),\" / \",IF(ISBLANK(D9)=TRUE,\"Base data\",\"Your data\"))","v":"Base data / Base data"}]
[null,"Protein",{"$nulls":5},"Protein",3.3500000000000002E-2,{"$nulls":4},"Protein",{"$f":"IF(ISBLANK(C10)=TRUE,I10,C10)","v":3.3500000000000002E-2},{"$f":"IF(ISBLANK(D10)=TRUE,I10,D10)","v":3.3500000000000002E-2},{"$f":"CONCATENATE(IF(ISBLANK(C10)=TRUE,\"Base data\",\"Your data\"),\" / \",IF(ISBLANK(D10)=TRUE,\"Base data\",\"Your data\"))","v":"Base data / Base data"},null,null,"RESULTS"]
[null,"Solids Not Fat",null,null,"calculated if left blank",null,null,"Solids Not Fat",{"$f":"ROUND(I10/38.2%,4)","v":8.77E-2},"calculated",null,null,null,"Solids Not Fat",{"$f":"IF(ISBLANK(C11)=TRUE,ROUND(O10/38.2%,4),C11)","v":8.77E-2},{"$f":"IF(ISBLANK(D11)=TRUE,ROUND(P10/38.2%,4),D11)","v":8.77E-2},{"$f":"CONCATENATE(IF(ISBLANK(C11)=TRUE,\"Calculated\",\"Your data\"),\" / \",IF(ISBLANK(D11)=TRUE,\"Calculated\",\"Your data\"))","v":"Calculated / Calculated"},null,null,"AMPE:",{"$f":"'AMPE calc'!K12","v":28.726140781939129},"ppl"]
[{"$nulls":7},"(3yr average figures used for composition)",{"$nulls":11},"MCVE:",{"$f":"'MCVE calc'!K11","v":31.394491595741776},"ppl"]
[]
[null,"Costs (£/t product):",{"$nulls":5},"Costs (£/t product):","Combined",{"$nulls":4},"Costs (£/t product):"]
[null,"Butter",{"$nulls":5},"Butter",244,{"$nulls":4},"Butter",{"$f":"IF(ISBLANK(C15)=TRUE,I15,C15)","v":244},null,{"$f":"IF(ISBLANK(C15)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[null,"SMP",{"$nulls":5},"SMP",365,{"$nulls":4},"SMP",{"$f":"IF(ISBLANK(C16)=TRUE,I16,C16)","v":365},null,"Base data",null,null,"AFTER PROFIT MARGIN"]
[null,"BMP",{"$nulls":5},"BMP",365,{"$nulls":4},"BMP",{"$f":"IF(ISBLANK(C17)=TRUE,I17,C17)","v":365},null,"Base data",null,null,"AMPE:",{"$f":"IF('AMPE calc'!L12>0,U11-'AMPE calc'!L12,\"N.A.\")","v":"N.A."},"ppl"]
[null,"Cheddar",{"$nulls":5},"Cheddar",330,{"$nulls":4},"Cheddar",{"$f":"IF(ISBLANK(D18)=TRUE,I18,D18)","v":330},null,{"$f":"IF(ISBLANK(D18)=TRUE,\"Base data\",\"Your data\")","v":"Base data"},null,null,"MCVE:",{"$f":"IF('MCVE calc'!L11>0,U12-'MCVE calc'!L11,\"N.A.\")","v":"N.A."},"ppl"]
[null,"Whey Powder",{"$nulls":5},"Whey Powder",341,{"$nulls":4},"Whey Powder",{"$f":"IF(ISBLANK(D19)=TRUE,I19,D19)","v":341},null,{"$f":"IF(ISBLANK(D19)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[null,"Whey Butter",null,null,"Can be same as butter",null,null,"Whey Butter",244,"Same as butter",null,null,null,"Whey Butter",{"$f":"IF(ISBLANK(D20)=TRUE,I20,D20)","v":244},null,"Base data"]
[]
[{"$nulls":19},"FARM GATE PRICE"]
[null,"Prices (£/tonne):",{"$nulls":5},"Prices (£/tonne), 2020 average:",{"$nulls":5},"Prices (£/tonne):",{"$nulls":5},"AMPE:",{"$f":"IF(O54>0,U11-'AMPE calc'!L12-O54,\"N.A.\")","v":"N.A."},"ppl"]
[null,"Butter",{"$nulls":5},"Butter",2950,{"$nulls":4},"Butter",{"$f":"IF(ISBLANK(C24)=TRUE,I24,C24)","v":2950},null,{"$f":"IF(ISBLANK(C24)=TRUE,\"Base data\",\"Your data\")","v":"Base data"},null,null,"MCVE:",{"$f":"IF(O55>0,U12-'MCVE calc'!L11-O55,\"N.A.\")","v":"N.A."},"ppl"]
[null,"SMP",{"$nulls":5},"SMP",1963,{"$nulls":4},"SMP",{"$f":"IF(ISBLANK(C25)=TRUE,I25,C25)","v":1963},null,"Base data"]
[null,"Lactose powder",{"$nulls":5},"Lactose powder",850,{"$nulls":4},"Lactose powder",{"$f":"IF(ISBLANK(C26)=TRUE,I26,C26)","v":850},null,"Base data"]
[null,"BMP",null,null,"calculated if left blank",null,null,"BMP",{"$f":"I25-103","v":1860},"Estimated using SMP price -103",null,null,null,"BMP",{"$f":"IF(ISBLANK(C27)=TRUE,O25-103,C27)","v":1860},null,{"$f":"IF(ISBLANK(C27)=TRUE,\"Calculated\",\"Your data\")","v":"Calculated"}]
[null,"Mild Cheddar",{"$nulls":5},"Mild Cheddar",2903,{"$nulls":4},"Mild Cheddar",{"$f":"IF(ISBLANK(D28)=TRUE,I28,D28)","v":2903},null,{"$f":"IF(ISBLANK(D28)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[null,"Whey powder",{"$nulls":5},"Whey powder",666,{"$nulls":4},"Whey powder",{"$f":"IF(ISBLANK(D29)=TRUE,I29,D29)","v":666},null,"Base data"]
[null,"Whey butter",null,null,"calculated if left blank",null,null,"Whey butter",{"$f":"I24-300","v":2650},"Estimated using butter price -300",null,null,null,"Whey butter",{"$f":"IF(ISBLANK(D30)=TRUE,O24-300,D30)","v":2650},null,{"$f":"IF(ISBLANK(D30)=TRUE,\"Calculated\",\"Your data\")","v":"Calculated"}]
[{"$nulls":13},"Base data uses 2020 average prices"]
[]
[null,"Lactose addition to SMP (%):",{"$nulls":5},"Lactose addition to SMP (%):",{"$nulls":5},"Lactose addition to SMP (%):"]
[null,"% of SMP by weight",{"$nulls":5},"% of SMP by weight",8.5000000000000006E-2,{"$nulls":4},"% of SMP by weight",{"$f":"IF(ISBLANK(C34)=TRUE,I34,C34)","v":8.5000000000000006E-2},null,{"$f":"IF(ISBLANK(C34)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[]
[]
[null,"Processing losses (%):",{"$nulls":5},"Processing losses (%):",{"$nulls":5},"Processing losses (%):"]
[null,"Butter",{"$nulls":5},"Butter",0.01,{"$nulls":4},"Butter",{"$f":"IF(ISBLANK(C38)=TRUE,I38,C38)","v":0.01},null,{"$f":"IF(ISBLANK(C38)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[null,"SMP",{"$nulls":5},"SMP",5.0000000000000001E-3,{"$nulls":4},"SMP",{"$f":"IF(ISBLANK(C39)=TRUE,I39,C39)","v":5.0000000000000001E-3},null,"Base data"]
[null,"BMP",null,null,"calculated if left blank",null,null,"BMP",{"$f":"I39","v":5.0000000000000001E-3},"Same as SMP",null,null,null,"BMP",{"$f":"IF(ISBLANK(C40)=TRUE,O39,C40)","v":5.0000000000000001E-3},null,{"$f":"IF(ISBLANK(C40)=TRUE,\"Calculated\",\"Your data\")","v":"Calculated"}]
[null,"Mild Cheddar",{"$nulls":5},"Mild Cheddar",7.4999999999999997E-3,{"$nulls":4},"Mild Cheddar",{"$f":"IF(ISBLANK(D41)=TRUE,I41,D41)","v":7.4999999999999997E-3},null,{"$f":"IF(ISBLANK(D41)=TRUE,\"Base data\",\"Your data\")","v":"Base data"}]
[null,"Whey powder",{"$nulls":5},"Whey powder",0.01,{"$nulls":4},"Whey powder",{"$f":"IF(ISBLANK(D42)=TRUE,I42,D42)","v":0.01},null,"Base data"]
[]
[]
[null,"Numbers below this point are optional and not included",{"$nulls":5},"Numbers below this point are optional and not included",{"$nulls":5},"Numbers below this point are optional and not included"]
[null,"in standard AMPE/MCVE calculations",{"$nulls":5},"in standard AMPE/MCVE calculations",{"$nulls":5},"in standard AMPE/MCVE calculations"]
[]
[null,"Processor profit margin (as % of sales prices):",{"$nulls":5},"Processor profit margin (ppl):",{"$nulls":5},"Processor profit margin (as % of sales prices):"]
[null,"AMPE",{"$nulls":5},"AMPE",0,{"$nulls":4},"AMPE",{"$f":"IF(ISBLANK(C49)=TRUE,I49,C49)","v":0},null,{"$f":"IF(ISBLANK(C49)=TRUE,\"Excluded\",\"Your data\")","v":"Excluded"}]
[null,"MCVE",{"$nulls":5},"MCVE",0,{"$nulls":4},"MCVE",{"$f":"IF(ISBLANK(D50)=TRUE,I50,D50)","v":0},null,{"$f":"IF(ISBLANK(D50)=TRUE,\"Excluded\",\"Your data\")","v":"Excluded"}]
[]
[]
[null,"Haulage cost from farm to factory (ppl):",{"$nulls":5},"Haulage cost from farm to factory (ppl):",{"$nulls":5},"Haulage cost from farm to factory (ppl):"]
[null,"AMPE",{"$nulls":5},"AMPE",0,{"$nulls":4},"AMPE",{"$f":"IF(ISBLANK(C54)=TRUE,I54,C54)","v":0},null,{"$f":"IF(ISBLANK(C54)=TRUE,\"Excluded\",\"Your data\")","v":"Excluded"}]
[null,"MCVE",{"$nulls":5},"MCVE",0,{"$nulls":4},"MCVE",{"$f":"IF(ISBLANK(D55)=TRUE,I55,D55)","v":0},null,{"$f":"IF(ISBLANK(D55)=TRUE,\"Excluded\",\"Your data\")","v":"Excluded"}]

{"sheet":"Base costs","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Proposed costs (£'s per tonne of product)"]
["UK","Butter","SMP","BMP","Cheddar","Whey Powder"]
["Energy",43,138,138,50,134]
["Labour",70,70,70,75,70]
["Raw mat",21,21,21,61,21]
["Chem, water, waste",10,25,25,12,25]
["Maintenance",20,25,25,25,25]
["Storage",20,6,6,30,6]
["Depreciation",30,50,50,42]
["General/admin",30,30,30,35,60]
["Total",244,365,365,330,341]
[null,null,"Excl. lactose cost"]
[]
["Energy assumptions split:"]
["Electricity",0.5,0.5,0.5,0.5,0.3]
["Gas",0.5,0.5,0.5,0.5,0.7]
[]
["Lactose addition",null,102,"kg per tonne of powder"]
["Lactose powder addition",null,55.556687452584328,"Now using monthly averages"]

{"sheet":"AMPE calc","index":2,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[[3,0,5,0],[7,0,8,0],[9,0,11,0],[13,0,14,0],[15,0,16,0]]}
[]
["yield",{"$nulls":4},"Costs",null,null,"prices & AMPE",null,null,"Profit margin"]
["Butter, SMP and BMP yield calculation",null,null,null,"Price £t","Butter",{"$f":"'Data Entry'!O15","v":244},null,"AMPE Calculation",null,null,{"$f":"'Data Entry'!O49","v":0}]
["Composition of milk","Fat",{"$f":"'Data Entry'!O9","v":4.1000000000000002E-2},null,null,"BMP",{"$f":"'Data Entry'!O17","v":365},null,"Price £t","Butter",{"$f":"'Data Entry'!O24","v":2950},{"$f":"K4*$L$3","v":0}]
[null,"Protein",{"$f":"'Data Entry'!O10","v":3.3500000000000002E-2},null,null,"SMP (ex lactose)",{"$f":"'Data Entry'!O16","v":365},null,null,"SMP",{"$f":"'Data Entry'!O25","v":1963},{"$f":"K5*$L$3","v":0}]
[null,"Solids not fat",{"$f":"'Data Entry'!O11","v":8.77E-2},{"$nulls":6},"Lactose",{"$f":"'Data Entry'!O26","v":850},{"$f":"K6*$L$3","v":0}]
["Composition of cream","Fat",0.4,{"$nulls":6},"BMP",{"$f":"'Data Entry'!O27","v":1860},{"$f":"K7*$L$3","v":0}]
["                            ","Fat",0.81499999999999995,{"$nulls":5},"components","Butter",{"$f":"(K4-G3)*100/$D26","v":13.597989949748744},{"$f":"(L4)*100/$D26","v":0}]
[null,"Solids not fat",1.7000000000000001E-2,{"$nulls":6},"BMP",{"$f":"(K7-G4)*100/$D38","v":0.73428290766208248},{"$f":"(L7)*100/$D38","v":0}]
["Composition of Buttermilk","Fat",5.0000000000000001E-3,{"$nulls":6},"SMP",{"$f":"(K5-G5-K6*C33)*100/$D39","v":14.393867924528301},{"$f":"(L5)*100/$D39","v":0}]
[null,"Solids not fat",{"$f":"(1-C10)/(1-C4)*C6","v":9.0992179353493213E-2}]
[null,"Total Solids",{"$f":"C11+C10","v":9.5992179353493218E-2},{"$nulls":5},"AMPE",null,{"$f":"SUM(K8:K10)","v":28.726140781939129},{"$f":"SUM(L8:L10)","v":0}]
["BMP","Total Solids",0.98499999999999999]
["Composition of SMP","Total Solids",0.98499999999999999]
[null,"Protein",0.34]
["Composition of  skim","Solids not fat",{"$f":"C6/(1-C4)","v":9.1449426485922844E-2}]
[null,"Fat",5.9999999999999995E-4]
["Weight of milk","kg/lit",1.02969]
["Volume of milk","kgs",100]
["Kgs of cream","kgs",{"$f":"C19*(C4-C17)/(C7-C17)","v":10.115172759138707},{"$f":"C19*(C4-C17)/C7","v":10.1}]
["kgs butter","kgs",{"$f":"C20*(C7-C10)/(C8-C10)","v":4.9327077035306051}]
["kgs buttermilk","kgs",{"$f":"(C20-C21)*(1-C23)","v":5.1306404050520209}]
["Loss",null,{"$f":"'Data Entry'!O38","v":0.01}]
["kgs butter","kgs",{"$f":"C21*(1-C23)","v":4.883380626495299}]
["1 tonne butter requires","kg milk",{"$f":"C19/C24*1000","v":20477.61738199136}]
["1 tonne butter requires","litres milk",{"$f":"C25/C$18","v":19887.167382407675},{"$f":"ROUND(C26/100,0)*100","v":19900},"Rounded"]
["kgs of SMP and buttermilk","kgs",{"$f":"C19-C21","v":95.06729229646939}]
["Solids in SMP and buttermilk","kgs",{"$f":"C19*(C6+C4)-C21*(C8+C9)","v":8.7659871906625391}]
["Solids as % of volume",null,{"$f":"C28/C27","v":9.2208234597926902E-2}]
["Loss SMP",null,{"$f":"'Data Entry'!O39","v":5.0000000000000001E-3}]
["Loss BMP",null,{"$f":"'Data Entry'!O40","v":5.0000000000000001E-3}]
["Protein in SMP before std","%",{"$f":"(C5/(1-C4+C17))/C29","v":0.37860370580724156},null,{"$f":"C32*(1-C33)","v":0.34642239081362602}]
["Addition of lactose powder","%",{"$f":"'Data Entry'!O34","v":8.5000000000000006E-2}]
["Cost of lactose powder","£/t SMP",{"$f":"C33*'Data Entry'!O26","v":72.25}]
["kgs of powder","kgs",{"$f":"C27*(1-C30)*C29/C14*(1+C33)","v":9.6076554531568625}]
["kgs of BMP","kgs",{"$f":"C22*(1-C31)*(C16+C17)/C13","v":0.47706715152953172}]
["kgs of SMP","kgs",{"$f":"(C35-C36)","v":9.1305883016273306}]
["1 tonne BMP requires","litres milk",{"$f":"C19/C36*1000/C$18","v":203570.10035118108},{"$f":"ROUND(C38/100,0)*100","v":203600},"Rounded"]
["1 tonne SMP requires","litres milk",{"$f":"C19/C37*1000/C$18","v":10636.40202612245},{"$f":"ROUND(C39/100,0)*100","v":10600},"Rounded"]

{"sheet":"MCVE calc","index":3,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[[24,0,26,0],[28,0,30,0],[2,0,4,0],[6,0,8,0],[9,0,10,0],[14,0,16,0],[17,0,19,0],[20,0,22,0]]}
[]
["Cheddar and whey yield calculator",{"$nulls":4},"costs",null,null,"prices and MCVE",null,null,"Profit margin"]
["Composition of milk","Fat",{"$f":"'Data Entry'!P9","v":4.1000000000000002E-2},null,"price","cheddar",{"$f":"'Data Entry'!O18","v":330},null,"MCVE calculation",null,null,{"$f":"'Data Entry'!O50","v":0}]
[null,"Protein",{"$f":"'Data Entry'!P10","v":3.3500000000000002E-2},null,null,"whey powder",{"$f":"'Data Entry'!O19","v":341},null,"price £t","Mild Cheddar",{"$f":"'Data Entry'!O28","v":2903},{"$f":"K4*$L$3","v":0}]
[null,"Solids not fat",{"$f":"'Data Entry'!P11","v":8.77E-2},null,null,"whey butter",{"$f":"'Data Entry'!O15","v":244},null,null,"Whey powder",{"$f":"'Data Entry'!O29","v":666},{"$f":"K5*$L$3","v":0}]
["Weight of milk","kg/lit",1.02969,{"$nulls":6},"est. Whey butter",{"$f":"'Data Entry'!O30","v":2650},{"$f":"K6*$L$3","v":0}]
["Composition of cheddar","Fat",0.34,{"$nulls":5},"components","Mild Cheddar",{"$f":"(K4-G3)*100/$D14","v":28.274725274725274},{"$f":"(L4)*100/$D14","v":0}]
[null,"Protein",0.254,{"$nulls":6},"Whey powder",{"$f":"(K5-G4)*100/$D34","v":1.9461077844311376},{"$f":"(L5)*100/$D34","v":0}]
[null,"Other SNF",2.8000000000000001E-2,{"$nulls":6},"est. Whey butter",{"$f":"(K6-G5)*100/$D37","v":1.1736585365853658},{"$f":"(L6)*100/$D37","v":0}]
["Composition of Unsalted Butter","Fat",{"$f":"'AMPE calc'!C8","v":0.81499999999999995}]
[null,"Solids not fat",1.7000000000000001E-2,{"$nulls":5},"MCVE",null,{"$f":"SUM(K7:K9)","v":31.394491595741776},{"$f":"SUM(L7:L9)","v":0}]
["Loss from cheese","%",{"$f":"'Data Entry'!O41","v":7.4999999999999997E-3}]
["Casein to make 1 tonne cheese","kgs",{"$f":"1000*C8*(1+C12)","v":255.90500000000003}]
["1 tonne of cheddar requires","litres milk",{"$f":"1000/((C3*0.88+C4*0.74)*1.09/SUM(C7:C9))/C6","v":9104.4578566015934},{"$f":"ROUND(C14/100,0)*100","v":9100},"Rounded"]
["In 1 tonne cheese (kgs)","Fat",{"$f":"1000*C7*(1+C12)","v":342.55}]
[null,"Protein",{"$f":"C13","v":255.90500000000003}]
[null,"Other SNF",{"$f":"1000*C9","v":28}]
["Losses from cheese make (kgs)","Fat",{"$f":"C15*C$12","v":2.5691250000000001}]
[null,"Protein",{"$f":"C16*C$12","v":1.9192875000000003}]
[null,"Other SNF",{"$f":"C17*C$12","v":0.21}]
["Remaining in whey (kgs)","Fat",{"$f":"C14*C6*C3-C15-C18","v":39.246412624927913}]
[null,"Protein",{"$f":"C14*C6*C4-C16-C19","v":56.230481047197138}]
[null,"Other SNF",{"$f":"C14*C6*(C5-C4)-C17-C20","v":479.90249120173394}]
["Loss from whey","%",{"$f":"'Data Entry'!O42","v":0.01}]
["Losses from whey powder make (kgs)","Fat",{"$f":"C21*C$24","v":0.39246412624927912}]
[null,"SNF",{"$f":"(C22+C23)*C$24","v":5.3613297224893106}]
[null,"All solids",{"$f":"C31*C$24","v":5.3342550073907402}]
["Whey powder","Fat",5.0000000000000001E-3]
["Solids in whey powder (kgs)","Fat",{"$f":"C30*C28","v":2.6538582126322088}]
[null,"SNF",{"$f":"(C23+C22)-C26","v":530.77164252644172}]
[null,"All solids",{"$f":"C30+C29","v":533.42550073907398}]
["Dry matter of whey powder","%",0.98]
["kgs of whey powder","All solids",{"$f":"C31/C32","v":544.31173544803471}]
["1 tonne of whey requires","litres milk",{"$f":"1000/C33*C14","v":16726.55073127813},{"$f":"ROUND(C34/100,0)*100","v":16700},"Rounded"]
["Used in whey butter (kgs)","Fat",{"$f":"C21-C29-C25","v":36.200090286046425}]
["Butter made from 1t cheese","kgs",{"$f":"C35/C10","v":44.417288694535493},"currently no butter loss %"]
["1 tonne of butter requires","litres milk",{"$f":"1000/C36*C14","v":204975.5427264898},{"$f":"ROUND(C37/100,0)*100","v":205000},"Rounded"]